// Copyright 2007-2010 Comdiv (F. Sadykov) - http://code.google.com/u/fagim.sadykov/
// Supported by Media Technology LTD 
//  
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//  
//      http://www.apache.org/licenses/LICENSE-2.0
//  
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
// 
// MODIFICATIONS HAVE BEEN MADE TO THIS FILE
using Comdiv.Design;
using NHibernate;

namespace Comdiv.Persistence{
    public static class SessionExtensions{
        [Fluent]
        public static ISession executeNonQuery(this ISession session, string sql){
            var c = session.Connection;
            var com = c.CreateCommand();
            com.CommandText = sql;
            com.ExecuteNonQuery();
            return session;
        }

        public static void free(this ISession session){
            if (session == null){
                return;
            }
            if (!session.IsOpen){
                session.Dispose();
                return;
            }
            if (session.Transaction != null){
                if (session.Transaction.IsActive){
                    session.Transaction.Rollback();
                }
            }
            session.Close();
            session.Dispose();
        }
    }
}